-- 上机练习一
-- 8.1
BEGIN;
insert into t_student(id,student_name,age,gender,birthday,classID,begin_year)VALUES(3007,'张佳豪',18,'女','2005-10-31',3,2023);
UPDATE t_student set birthday = '2005-10-31' WHERE student_name ='张佳豪';
insert into t_score (exam_score,studentID,classID) values(88,3007,2);
DELETE FROM t_student WHERE age < 18;
COMMIT;
ROLLBACK;
-- 上机练习二
CREATE TABLE account(
id,INT AUTO_INCREMENT PRIMARY KEY,
account_name VARCHAR(20) NOT NULL,
phone VARCHAR(11) NOT NULL,
balance DECIMAL(30,5)
);
INSERT INTO account VALUES ('6225214702630552','张三','13541522563',100);
INSERT INTO account VALUES ('6225214702630562','李四','13012123443',100);

-- 上机练习三